#!/usr/bin/env ruby

require 'dbi'
require 'database'

Database.instance.connect('DBI:Mysql:smsclient', 'ag3nt', 'password')

email = 'abc@hotmail.com'
sql = "select name, email, number, keyword, provision_date, expiration_date from customers where email = '#{email}' and enabled=true"
Database.instance.connection.select_all(sql) { |row| p row }




